﻿IF EXISTS (SELECT * from sys.procedures p left join sys.schemas s on p.schema_id = s.schema_id where p.name='category_insert' and s.name='Crm')
DROP PROCEDURE [Crm].category_insert
GO
CREATE PROCEDURE [Crm].category_insert 
@PK uniqueidentifier, 
@Name nvarchar(200), 
@Description nvarchar(250), 
@Color varchar(10)
AS
BEGIN
INSERT INTO [Crm].[Categories]
([id_category], [name], [description], [color])
VALUES (@PK,@Name,@Description,@Color)
END